home *** CD-ROM | disk | FTP | other *** search
- unit DBChart_Aggregates;
-
- interface
-
- uses
- Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
- Base_DBChart, TeeProcs, TeEngine, Chart, DBChart, ExtCtrls, StdCtrls, Db,
- DBTables, DBClient, Provider, Series;
-
- type
- TDBChartAggregate = class(TBaseDBChart)
- CheckBox1: TCheckBox;
- Series1: TBarSeries;
- DataSource1: TDataSource;
- DataSetProvider1: TDataSetProvider;
- ClientDataSet1: TClientDataSet;
- Table1: TTable;
- ClientDataSet1Total: TAggregateField;
- ClientDataSet1MyItemsTotal: TAggregateField;
- procedure CheckBox1Click(Sender: TObject);
- procedure FormShow(Sender: TObject);
- private
- { Private declarations }
- public
- { Public declarations }
- end;
-
- Var DBChartAggregate : TDBChartAggregate;
-
- implementation
-
- {$R *.DFM}
-
- procedure TDBChartAggregate.CheckBox1Click(Sender: TObject);
- begin
- Screen.Cursor:=crHourGlass;
- try
- Series1.YValues.ValueSource:='MyTotal;MyItemsTotal'; { <-- aggregate fields }
-
- { things to remember: }
- ClientDataSet1.AggregatesActive:=CheckBox1.Checked;
-
- Table1.Active:=CheckBox1.Checked;
- ClientDataSet1.Active:=Table1.Active;
- finally
- Screen.Cursor:=crDefault;
- end;
- end;
-
- procedure TDBChartAggregate.FormShow(Sender: TObject);
- begin
- inherited;
- CheckTable(Table1);
- end;
-
- initialization
- RegisterClass(TDBChartAggregate);
- end.
-